group (streaming)
Short Description
The group (streaming) aggregate node is used for functions such as count(), max(), min() sum() and avg().
Detailed Description​
The group (streaming) aggregate node is used for functions such as COUNT(), MAX(), MIN() SUM() or AVG().
A supporting index is in place allowing group aggregation to take place via streaming rather than building a hash table. This gives query performance advantages but beware of the maintenance overhead of having too many indexes.
Additional Links​
- CockroachDB Docs - Aggregate functions
- CockroachDB Docs - Supported Join Algorithms
- CockroachDB Docs - Cost Based Optimizer
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.